UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'clzjxWE6LDTdKrRw7HBE+3bj1+O/xVnJwv04u3fmEN0='
WHERE
key_id = 'd8b1fa37a2c81aae1921e7aef819bcb9e7c9715e0556ed959a86eb1fae035362'
AND (
token = 'clzjxWE6LDTdKrRw7HBE+3bj1+O/xVnJwv04u3fmEN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)