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