UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piPlfY0YclSMq1AF/IozR0qIv13qclG80+X2/CXWokE='
WHERE
key_id = 'f51db910fddacd01b20fe8a1f9affc104754ec8be0bf32f675827b984ecc9af7'
AND (
token = 'piPlfY0YclSMq1AF/IozR0qIv13qclG80+X2/CXWokE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)