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