UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPgCxZwwuu6VAx7VCdcTVm+uoPfbYIftHpbKoZjSsv4='
WHERE
key_id = '2a47ddc8732d4d5825287fd0177bd9a60ab9592cd79b70d241597afa231e7fb8'
AND (
token = 'pPgCxZwwuu6VAx7VCdcTVm+uoPfbYIftHpbKoZjSsv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)