UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v44eHHbZlB5gvrxJ7smo9ae85Lo+jALpmSUBUTDsdqU='
WHERE
key_id = 'b97bf1a4cc664503575512f397e35be8c1e1e028411b82c196abcd60d993f479'
AND (
token = 'v44eHHbZlB5gvrxJ7smo9ae85Lo+jALpmSUBUTDsdqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)