UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aXO+qzL6luoaBeY5wWk8lxUUcsNzXJbnmhItjxkwl+8='
WHERE
key_id = 'a33df20e4a868dee767798de6ac09ee0b86d5fb73657a269c759e5ac8aac79f1'
AND (
token = 'aXO+qzL6luoaBeY5wWk8lxUUcsNzXJbnmhItjxkwl+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)