UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EMlMLJjK+sWtC07OrLS2Za87R6OyGSQCwYWjO16CQGQ='
WHERE
key_id = 'be9864c085fc30a5e493ec386b57ec5ab145ff59d31da8923187b9203dd1c48d'
AND (
token = 'EMlMLJjK+sWtC07OrLS2Za87R6OyGSQCwYWjO16CQGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)