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