UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2y+I8z7uzGJoIqatfQ05Uw2gNSUxKxJDW17toKX5sPs='
WHERE
key_id = 'f598a327cb731b0f52d060e1de1961f2c1008afd43d54c53a48f00f548e5e803'
AND (
token = '2y+I8z7uzGJoIqatfQ05Uw2gNSUxKxJDW17toKX5sPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)