UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWjw0rRLpdYeZlD7hZ+fb3mlxKtZeiuBdmmPtM5x8eE='
WHERE
key_id = '2a47d72f96184ac44c81df6da9e535920173afa842d475ceef220e25572568ab'
AND (
token = 'pWjw0rRLpdYeZlD7hZ+fb3mlxKtZeiuBdmmPtM5x8eE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)