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