UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gHjA6LDwKBo37gEmJHc4LgleWDwqMJu8ck8BriG/+c='
WHERE
key_id = '4409a3605b40985b509bd49f51005e5f6f628666796bc2cf6f7a4368d09edfef'
AND (
token = '5gHjA6LDwKBo37gEmJHc4LgleWDwqMJu8ck8BriG/+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)