UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aib3vgNgM/S6OxoUAU2bwORWrSpYDXlmisc/UsJBPNE='
WHERE
key_id = 'fe6c9f149b8cdf361072a5a948ff34ffb6d656def0702241c680309d737167e4'
AND (
token = 'aib3vgNgM/S6OxoUAU2bwORWrSpYDXlmisc/UsJBPNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)