UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'On8kKelBQQlwqddPGCC3djlAnK6bi8yZNmNF60bBGWM='
WHERE
key_id = 'ff130e59d8942150d0cc8f0771bcfa266e8e73e8508c88c8930a699fe7b16077'
AND (
token = 'On8kKelBQQlwqddPGCC3djlAnK6bi8yZNmNF60bBGWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)