UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VqzYeRC4CF8tGZRbPnoWIB9ZnJiCBV63ySs05shkfCs='
WHERE
key_id = '1c50d2edf105272b5160db5372684446aa30ccc12adf200568cfc0559174c40f'
AND (
token = 'VqzYeRC4CF8tGZRbPnoWIB9ZnJiCBV63ySs05shkfCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)