UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xaRpgC1myn5ox/Rg1O2GWtWy94vQs7dTjVT2KhYodwo='
WHERE
key_id = '07caeba91754766c1220d4f07185af440399a7b10932a5490b2d07cb2447652e'
AND (
token = 'xaRpgC1myn5ox/Rg1O2GWtWy94vQs7dTjVT2KhYodwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)