UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'niPrhfJIFTOz6EZOkRsNMi93/llM9jIoNM+zqT55XRs='
WHERE
key_id = '21418517046af03fe339b4b167e7d90f77b78b7cb12f2feb6ab2d2876f426179'
AND (
token = 'niPrhfJIFTOz6EZOkRsNMi93/llM9jIoNM+zqT55XRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)