UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+GbcsOy1oPC6bpnPvwgydaokySeepPbyE6d4a3GSQw='
WHERE
key_id = 'b43afb8b7c897d9aa3247210539c32467e6b58039a42c27ed23c847b546771c3'
AND (
token = 'Z+GbcsOy1oPC6bpnPvwgydaokySeepPbyE6d4a3GSQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)