UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hYRgOeSKccy7/ut7YFUrQ3oE5yXBRh/cyLR20hIm+k='
WHERE
key_id = 'bcea7a5cff14baed7ea958d02e7bb8d7afea498989e076c93269d09c1f3e5e5c'
AND (
token = '9hYRgOeSKccy7/ut7YFUrQ3oE5yXBRh/cyLR20hIm+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)