UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7d5oSYCCZUB5tM2UPHfSJ0K6CJ78IVIi2c1ZDp3ciAM='
WHERE
key_id = '9f3cd11d2b32710b039fca44651b318b7d577c45db66ef8af9b7c1c18c398c71'
AND (
token = '7d5oSYCCZUB5tM2UPHfSJ0K6CJ78IVIi2c1ZDp3ciAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)