UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dP5SVhcKmbXiqe8/U+JCEwgch57+KiC/UqtJcAtndE='
WHERE
key_id = '4ccdf5149f26871bcf996c0179c2686649cd7afa8de5bf702b6ce027e64be564'
AND (
token = '8dP5SVhcKmbXiqe8/U+JCEwgch57+KiC/UqtJcAtndE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)