UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7yPPTSCP0uL8feUOtVnGThCfLVF2dOwHcI6d5XZOto8='
WHERE
key_id = '97d328a97539f08fe31d06cc8d409a41ea74fe0cecff112423bd1c3101aad152'
AND (
token = '7yPPTSCP0uL8feUOtVnGThCfLVF2dOwHcI6d5XZOto8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)