UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kjc5rdkRRVTdruyvaqNu3i8GzPqe18MM7ayMjTD20N8='
WHERE
key_id = '23d0a21f8cb9938d8806f7dfbedc85417906a7deb23bcd3627de2b8de5768235'
AND (
token = 'kjc5rdkRRVTdruyvaqNu3i8GzPqe18MM7ayMjTD20N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)