UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oN6IaUNA1ZpnYygq8NoFkUynCx3pNtH/MopQ5oX3et0='
WHERE
key_id = '87b1b6aded1697812e53320e7471984b38ca0b0c6058a8472cfa5022ea8036d1'
AND (
token = 'oN6IaUNA1ZpnYygq8NoFkUynCx3pNtH/MopQ5oX3et0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)