UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKrNJCPKFt959a+iyQXXNefe6T5MuDJJqjPKyTV5V94='
WHERE
key_id = 'e2ce26ba5d75e026b37117856f30d37391e370d414c2b557707f0a63f454454c'
AND (
token = 'pKrNJCPKFt959a+iyQXXNefe6T5MuDJJqjPKyTV5V94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)