UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YiGDhL9zMUVao8hbOzvzuwUq45J6R4/U4VIQbCpFXbU='
WHERE
key_id = 'd0e7298fc76b91d075acec1e6c2a043b6a82b6df697e4a282b8200793f37b9cb'
AND (
token = 'YiGDhL9zMUVao8hbOzvzuwUq45J6R4/U4VIQbCpFXbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)