UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Zu2WPTPNRicZo0OSB5wwyFZZ/VDzryagLfx8Z/jMvM='
WHERE
key_id = '3df1e5a38c0e58a17bec1b6be062e4680cb8d115549bde8aca623592a06a3254'
AND (
token = '1Zu2WPTPNRicZo0OSB5wwyFZZ/VDzryagLfx8Z/jMvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)