UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HidEuoE9Ibq7MNNYOGODj/9p6K1KL/eAhWmk2pBIJe0='
WHERE
key_id = '31d9311b71378925788c68253d4581794537c600863e634263e02e23b172aefa'
AND (
token = 'HidEuoE9Ibq7MNNYOGODj/9p6K1KL/eAhWmk2pBIJe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)