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