UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZGYY3wH4IumEBl9igY4Kk8uS6H72/E3/pSKvyjEh1Hk='
WHERE
key_id = '0de1160a50f4d048c6eae3c0af1f3aa7a437f8d222ccbf54f58783cc1eb37995'
AND (
token = 'ZGYY3wH4IumEBl9igY4Kk8uS6H72/E3/pSKvyjEh1Hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)