UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1uAcrzQ+1PwuDqNpx9QvWgWYeCJa6eRlI2W/Er/JnFg='
WHERE
key_id = 'a9a5815864f7efaf34ef2ef6da7ee1f597ae7b8206979e0db1887147be53ac46'
AND (
token = '1uAcrzQ+1PwuDqNpx9QvWgWYeCJa6eRlI2W/Er/JnFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)